USE [totem]
GO

/****** Object:  StoredProcedure [dbo].[CONRol]    Script Date: 05/23/2012 17:21:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE PROCEDURE [dbo].[CONRol]

@NombreRol1 varchar (50)

AS

BEGIN

select TIPOROL,DESCRIPCIONROL
from ROL 
where NOMBREROL=@NombreRol1
		
END

SET ANSI_NULLS ON
GO

